use vudu
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		JUAN
-- este procedimiento retorna el pensum
-- y su estatus 
-- =============================================
CREATE PROCEDURE  sp_devolver_pensum
	@id_pensum int
AS
BEGIN
	SELECT id_Pensum,statusPensum 
	FROM Pensum
	WHERE id_Pensum=@id_pensum
	
END
GO
